DROP DATABASE IF EXISTS webdb;
DROP USER IF EXISTS 'web'@'localhost';

CREATE DATABASE webdb
  DEFAULT CHARACTER SET utf8
  COLLATE utf8_unicode_ci;

CREATE USER 'web'@'localhost' IDENTIFIED BY 'web';

GRANT ALL PRIVILEGES ON webdb.* TO 'web'@'localhost';

FLUSH PRIVILEGES;

USE webdb;


--
-- Host: localhost    Database: webdb
-- ------------------------------------------------------


--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `iduser` varchar(45) NOT NULL,
  `pass` varchar(60) NOT NULL,
  `name` varchar(45) NOT NULL,
  PRIMARY KEY (`iduser`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_spanish2_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES ('user@domain.ext','$2y$10$vGQRplhY86sLs1FGn1s0.e/0k0yM0xtBGjUCL8BWmfHqBzyFPDrYG','Nombre');


